TG: sql_for_qa/808

SQL для тестировщика

(Oracle) В таблице STORES есть столбец START_DATE с типом данных DATE, содержащий дату вставки строки. Вы хотите отобразить только те строки, в которых дата START_DATE находится в пределах последних 25 месяцев. Какое предложение WHERE можно использовать?

Anonymous Quiz

A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25

B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25

C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25

D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE

193 answered

www.tg-me.com/jp/SQL для тестировщика/com.sql_for_qa/808

2.5K viewsJun 4 at 05:06

tg-me.com/sql_for_qa/808

Create: 2025-06-04
Last Update: 2025-06-30 14:52:13

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/808

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram announces Anonymous Admins

The cloud-based messaging platform is also adding Anonymous Group Admins feature. As per Telegram, this feature is being introduced for safer protests. As per the Telegram blog post, users can “Toggle Remain Anonymous in Admin rights to enable Batman mode. The anonymized admin will be hidden in the list of group members, and their messages in the chat will be signed with the group name, similar to channel posts.”

Telegram Auto-Delete Messages in Any Chat

Some messages aren’t supposed to last forever. There are some Telegram groups and conversations where it’s best if messages are automatically deleted in a day or a week. Here’s how to auto-delete messages in any Telegram chat. You can enable the auto-delete feature on a per-chat basis. It works for both one-on-one conversations and group chats. Previously, you needed to use the Secret Chat feature to automatically delete messages after a set time. At the time of writing, you can choose to automatically delete messages after a day or a week. Telegram starts the timer once they are sent, not after they are read. This won’t affect the messages that were sent before enabling the feature.